﻿-- 获取全部角色对应的菜单
CREATE proc [dbo].[proc_AppRolesMenu_GetAllList]
as

	 select
		ARM.RoleId,
		AM.MenuId,
		AM.ParentId,
		AM.Title,
		isnull((select AC.CName from AppController AC where AM.Cid = AC.Id),'') as ControllerName,
		isnull((select AA.AName from AppAction AA where AM.Aid = AA.Id),'') as ActionName,
		AM.Sort
	 from
		 AppRolesMenu  ARM inner join AppMenu AM on ARM.MenuId=AM.MenuId Order by AM.Sort
